package com.patrol.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.patrol.pojo.TravelPath;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface TravelPathDao extends BaseMapper<TravelPath> {

    @Select("select latitude_x,longitude_y,task_id from task_travel_path where create_time between #{startDate} and #{endDate}")
    List<TravelPath> selectAllPathByDate(@Param("userId") Integer userId, @Param("startDate") String startDate, @Param("endDate") String endDate);
}
